{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 16,
   "id": "5d0c8385",
   "metadata": {},
   "outputs": [],
   "source": [
    "import pandas as pd"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 17,
   "id": "3a690ee8",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.salary</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.jobId</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>...</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>recruiter.recruiterName</th>\n",
       "      <th>recruiter.recruiterTitle</th>\n",
       "      <th>recruiter.imId</th>\n",
       "      <th>recruiter.imUserType</th>\n",
       "      <th>recruiter.chatted</th>\n",
       "      <th>recruiter.recruiterId</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>%7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"recruiterName\":\"梁女士\",\"jobId\":\"49036529\",\"imI...</td>\n",
       "      <td>[]</td>\n",
       "      <td>20230412095614</td>\n",
       "      <td>医药产品经理</td>\n",
       "      <td>15-20k</td>\n",
       "      <td>广州</td>\n",
       "      <td>49036529</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/2051572/</td>\n",
       "      <td>制药</td>\n",
       "      <td>1000-2000人</td>\n",
       "      <td>梁女士</td>\n",
       "      <td>NaN</td>\n",
       "      <td>d7754d4d4e4aa4da6dadb487287a091a</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>1cd0965588ebd1dba766278cd27a88c2</td>\n",
       "      <td>5bd962c38e50a3257f7c32d304a.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>%7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"recruiterName\":\"刘女士\",\"jobId\":\"58002363\",\"imI...</td>\n",
       "      <td>['产品开发', '产品规划', '产品运营']</td>\n",
       "      <td>20230421104505</td>\n",
       "      <td>电商产品经理</td>\n",
       "      <td>10-15k·13薪</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>58002363</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/9720899/</td>\n",
       "      <td>批发/零售</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>刘女士</td>\n",
       "      <td>人事经理</td>\n",
       "      <td>561ff6e28a2e9cb4aa6795a3148228ff</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>e478580dede58f33b410edb79f6d12d0</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>%7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"recruiterName\":\"王女士\",\"jobId\":\"56876529\",\"imI...</td>\n",
       "      <td>[]</td>\n",
       "      <td>20230510113709</td>\n",
       "      <td>Automation Product Manager</td>\n",
       "      <td>20-40k·13薪</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>56876529</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/8506529/</td>\n",
       "      <td>医疗器械</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>王女士</td>\n",
       "      <td>人力资源专员</td>\n",
       "      <td>24c1cab13ef9bc2e801c17c79e240538</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>57a52ed73fed146b4c632be0178bfd3f</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>%7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"recruiterName\":\"李女士\",\"jobId\":\"58230073\",\"imI...</td>\n",
       "      <td>['支付产品', '工具产品', '供应链产品', '产品规划', '产品设计', '需求分...</td>\n",
       "      <td>20230429161907</td>\n",
       "      <td>支付结算产品经理（供应链）</td>\n",
       "      <td>20-40k·16薪</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>58230073</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/8537928/</td>\n",
       "      <td>消费品</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>李女士</td>\n",
       "      <td>HR</td>\n",
       "      <td>01bdff5bdd175f73bed9c63c695716f7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>4cb038ce180249e5b6d6f34ea69aacf8</td>\n",
       "      <td>62201c0397e97d36de7fadb308u.png</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>%7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"recruiterName\":\"李先生\",\"jobId\":\"44389755\",\"imI...</td>\n",
       "      <td>['工具产品', '海外产品']</td>\n",
       "      <td>20230504101816</td>\n",
       "      <td>项目负责人-出海工具</td>\n",
       "      <td>50-60k·18薪</td>\n",
       "      <td>广州</td>\n",
       "      <td>44389755</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>在线社交/媒体</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>李先生</td>\n",
       "      <td>猎头顾问</td>\n",
       "      <td>a618aec32f807381e2a6e48d27d32952</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>7938d3385f4fa15e1077287a6124ac27</td>\n",
       "      <td>61c1856c1fe6ad2b061c38f408u.png</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>796</th>\n",
       "      <td>36</td>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"imId\":\"e225c3f62a005d602599e94...</td>\n",
       "      <td>['AI人工智能产品', 'IT互联网', '人工智能', '用户研究', '需求分析', ...</td>\n",
       "      <td>20221125101339</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>14-17k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>54434179</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/13240331/</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>杨女士</td>\n",
       "      <td>HR</td>\n",
       "      <td>e225c3f62a005d602599e94af0746e13</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2e7227dee6993722f405701a339a50b5</td>\n",
       "      <td>62a44db9eb7f9e008716ed4208u.png</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>797</th>\n",
       "      <td>37</td>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"imId\":\"1fe1f195fb9b578b4036597...</td>\n",
       "      <td>['产品经理', '智能硬件产品', '智能硬件', '车载产品', '行车记录仪']</td>\n",
       "      <td>20230426171852</td>\n",
       "      <td>高级产品经理（硬件产品）</td>\n",
       "      <td>20-30k</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>51415121</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/12274147/</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>王女士</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1fe1f195fb9b578b4036597854bcf58c</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>3008edc8b1b12656a3c5bc684e468568</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>798</th>\n",
       "      <td>38</td>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"imId\":\"694fd92f6c2e08c7e2ff452...</td>\n",
       "      <td>[]</td>\n",
       "      <td>20230209091607</td>\n",
       "      <td>护肤品产品开发经理</td>\n",
       "      <td>10-20k</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>55885211</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/13413369/</td>\n",
       "      <td>电子商务</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>麦女士</td>\n",
       "      <td>人事</td>\n",
       "      <td>694fd92f6c2e08c7e2ff452aa21dd897</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>5c70ee4140549e39609440013bae28b2</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>799</th>\n",
       "      <td>39</td>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"imId\":\"16c9e99cc7e10c1f062c1b1...</td>\n",
       "      <td>['电商产品', 'IT互联网', '电子商务', '产品设计', '移动端产品', '产品...</td>\n",
       "      <td>20220224164403</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州</td>\n",
       "      <td>47448393</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/12677101/</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>钟先生</td>\n",
       "      <td>人事经理</td>\n",
       "      <td>16c9e99cc7e10c1f062c1b1ee9c7454d</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>6b69b564e7d96f6957441703e35c1686</td>\n",
       "      <td>5f8f986aea60860b75384fab08u.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800</th>\n",
       "      <td>0</td>\n",
       "      <td>%7B%22ckId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"userId\":\"3008edc8b1b12656a3c5bc684e468568\",\"...</td>\n",
       "      <td>['嵌入式硬件产品', '产品经理', '硬件产品经理', '硬件产品', '车载产品', ...</td>\n",
       "      <td>20230426171852</td>\n",
       "      <td>嵌入式硬件产品经理</td>\n",
       "      <td>20-30k</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>51414013</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/12274147/</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>王女士</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1fe1f195fb9b578b4036597854bcf58c</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>3008edc8b1b12656a3c5bc684e468568</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>801 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0                                           dataInfo  \\\n",
       "0             0  %7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "1             1  %7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "2             2  %7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "3             3  %7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "4             4  %7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "..          ...                                                ...   \n",
       "796          36  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "797          37  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "798          38  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "799          39  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "800           0  %7B%22ckId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "\n",
       "                                            dataParams  \\\n",
       "0    {\"recruiterName\":\"梁女士\",\"jobId\":\"49036529\",\"imI...   \n",
       "1    {\"recruiterName\":\"刘女士\",\"jobId\":\"58002363\",\"imI...   \n",
       "2    {\"recruiterName\":\"王女士\",\"jobId\":\"56876529\",\"imI...   \n",
       "3    {\"recruiterName\":\"李女士\",\"jobId\":\"58230073\",\"imI...   \n",
       "4    {\"recruiterName\":\"李先生\",\"jobId\":\"44389755\",\"imI...   \n",
       "..                                                 ...   \n",
       "796  {\"jobKind\":\"2\",\"imId\":\"e225c3f62a005d602599e94...   \n",
       "797  {\"jobKind\":\"2\",\"imId\":\"1fe1f195fb9b578b4036597...   \n",
       "798  {\"jobKind\":\"2\",\"imId\":\"694fd92f6c2e08c7e2ff452...   \n",
       "799  {\"jobKind\":\"2\",\"imId\":\"16c9e99cc7e10c1f062c1b1...   \n",
       "800  {\"userId\":\"3008edc8b1b12656a3c5bc684e468568\",\"...   \n",
       "\n",
       "                                            job.labels  job.refreshTime  \\\n",
       "0                                                   []   20230412095614   \n",
       "1                             ['产品开发', '产品规划', '产品运营']   20230421104505   \n",
       "2                                                   []   20230510113709   \n",
       "3    ['支付产品', '工具产品', '供应链产品', '产品规划', '产品设计', '需求分...   20230429161907   \n",
       "4                                     ['工具产品', '海外产品']   20230504101816   \n",
       "..                                                 ...              ...   \n",
       "796  ['AI人工智能产品', 'IT互联网', '人工智能', '用户研究', '需求分析', ...   20221125101339   \n",
       "797        ['产品经理', '智能硬件产品', '智能硬件', '车载产品', '行车记录仪']   20230426171852   \n",
       "798                                                 []   20230209091607   \n",
       "799  ['电商产品', 'IT互联网', '电子商务', '产品设计', '移动端产品', '产品...   20220224164403   \n",
       "800  ['嵌入式硬件产品', '产品经理', '硬件产品经理', '硬件产品', '车载产品', ...   20230426171852   \n",
       "\n",
       "                      job.title  job.salary  job.dq  job.jobId  job.topJob  \\\n",
       "0                        医药产品经理      15-20k      广州   49036529        True   \n",
       "1                        电商产品经理  10-15k·13薪  广州-越秀区   58002363        True   \n",
       "2    Automation Product Manager  20-40k·13薪  广州-天河区   56876529       False   \n",
       "3                 支付结算产品经理（供应链）  20-40k·16薪  广州-番禺区   58230073       False   \n",
       "4                    项目负责人-出海工具  50-60k·18薪      广州   44389755       False   \n",
       "..                          ...         ...     ...        ...         ...   \n",
       "796                        产品经理      14-17k  广州-天河区   54434179       False   \n",
       "797                高级产品经理（硬件产品）      20-30k  广州-越秀区   51415121       False   \n",
       "798                   护肤品产品开发经理      10-20k  广州-海珠区   55885211       False   \n",
       "799                        产品经理      15-25k      广州   47448393       False   \n",
       "800                   嵌入式硬件产品经理      20-30k  广州-越秀区   51414013       False   \n",
       "\n",
       "     ...                                 comp.link comp.compIndustry  \\\n",
       "0    ...   https://www.liepin.com/company/2051572/                制药   \n",
       "1    ...   https://www.liepin.com/company/9720899/             批发/零售   \n",
       "2    ...   https://www.liepin.com/company/8506529/              医疗器械   \n",
       "3    ...   https://www.liepin.com/company/8537928/               消费品   \n",
       "4    ...                                       NaN           在线社交/媒体   \n",
       "..   ...                                       ...               ...   \n",
       "796  ...  https://www.liepin.com/company/13240331/             计算机软件   \n",
       "797  ...  https://www.liepin.com/company/12274147/             计算机软件   \n",
       "798  ...  https://www.liepin.com/company/13413369/              电子商务   \n",
       "799  ...  https://www.liepin.com/company/12677101/             计算机软件   \n",
       "800  ...  https://www.liepin.com/company/12274147/             计算机软件   \n",
       "\n",
       "    comp.compScale recruiter.recruiterName  recruiter.recruiterTitle  \\\n",
       "0       1000-2000人                     梁女士                       NaN   \n",
       "1           50-99人                     刘女士                      人事经理   \n",
       "2      5000-10000人                     王女士                    人力资源专员   \n",
       "3      5000-10000人                     李女士                        HR   \n",
       "4         100-499人                     李先生                      猎头顾问   \n",
       "..             ...                     ...                       ...   \n",
       "796          1-49人                     杨女士                        HR   \n",
       "797       100-499人                     王女士                       NaN   \n",
       "798         50-99人                     麦女士                        人事   \n",
       "799          1-49人                     钟先生                      人事经理   \n",
       "800       100-499人                     王女士                       NaN   \n",
       "\n",
       "                       recruiter.imId recruiter.imUserType  recruiter.chatted  \\\n",
       "0    d7754d4d4e4aa4da6dadb487287a091a                  2.0              False   \n",
       "1    561ff6e28a2e9cb4aa6795a3148228ff                  2.0              False   \n",
       "2    24c1cab13ef9bc2e801c17c79e240538                  2.0              False   \n",
       "3    01bdff5bdd175f73bed9c63c695716f7                  2.0              False   \n",
       "4    a618aec32f807381e2a6e48d27d32952                  2.0              False   \n",
       "..                                ...                  ...                ...   \n",
       "796  e225c3f62a005d602599e94af0746e13                  2.0              False   \n",
       "797  1fe1f195fb9b578b4036597854bcf58c                  2.0              False   \n",
       "798  694fd92f6c2e08c7e2ff452aa21dd897                  2.0              False   \n",
       "799  16c9e99cc7e10c1f062c1b1ee9c7454d                  2.0              False   \n",
       "800  1fe1f195fb9b578b4036597854bcf58c                  2.0              False   \n",
       "\n",
       "                recruiter.recruiterId         recruiter.recruiterPhoto  \n",
       "0    1cd0965588ebd1dba766278cd27a88c2  5bd962c38e50a3257f7c32d304a.jpg  \n",
       "1    e478580dede58f33b410edb79f6d12d0  5f8f986779c7cc70efbf36c008u.jpg  \n",
       "2    57a52ed73fed146b4c632be0178bfd3f  5f8f98648dbe6273dcf8515508u.jpg  \n",
       "3    4cb038ce180249e5b6d6f34ea69aacf8  62201c0397e97d36de7fadb308u.png  \n",
       "4    7938d3385f4fa15e1077287a6124ac27  61c1856c1fe6ad2b061c38f408u.png  \n",
       "..                                ...                              ...  \n",
       "796  2e7227dee6993722f405701a339a50b5  62a44db9eb7f9e008716ed4208u.png  \n",
       "797  3008edc8b1b12656a3c5bc684e468568  5f8f9865ea60860b75384fa508u.jpg  \n",
       "798  5c70ee4140549e39609440013bae28b2  5f8f9865ea60860b75384fa508u.jpg  \n",
       "799  6b69b564e7d96f6957441703e35c1686  5f8f986aea60860b75384fab08u.jpg  \n",
       "800  3008edc8b1b12656a3c5bc684e468568  5f8f9865ea60860b75384fa508u.jpg  \n",
       "\n",
       "[801 rows x 32 columns]"
      ]
     },
     "execution_count": 17,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "pd.read_excel(io=r'liepin_PM_0510.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 18,
   "id": "2cc4bad1",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<style scoped>\n",
       "    .dataframe tbody tr th:only-of-type {\n",
       "        vertical-align: middle;\n",
       "    }\n",
       "\n",
       "    .dataframe tbody tr th {\n",
       "        vertical-align: top;\n",
       "    }\n",
       "\n",
       "    .dataframe thead th {\n",
       "        text-align: right;\n",
       "    }\n",
       "</style>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>Unnamed: 0</th>\n",
       "      <th>dataInfo</th>\n",
       "      <th>dataParams</th>\n",
       "      <th>job.labels</th>\n",
       "      <th>job.refreshTime</th>\n",
       "      <th>job.title</th>\n",
       "      <th>job.salary</th>\n",
       "      <th>job.dq</th>\n",
       "      <th>job.jobId</th>\n",
       "      <th>job.topJob</th>\n",
       "      <th>...</th>\n",
       "      <th>comp.link</th>\n",
       "      <th>comp.compIndustry</th>\n",
       "      <th>comp.compScale</th>\n",
       "      <th>recruiter.recruiterName</th>\n",
       "      <th>recruiter.recruiterTitle</th>\n",
       "      <th>recruiter.imId</th>\n",
       "      <th>recruiter.imUserType</th>\n",
       "      <th>recruiter.chatted</th>\n",
       "      <th>recruiter.recruiterId</th>\n",
       "      <th>recruiter.recruiterPhoto</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>%7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"recruiterName\":\"梁女士\",\"jobId\":\"49036529\",\"imI...</td>\n",
       "      <td>[]</td>\n",
       "      <td>20230412095614</td>\n",
       "      <td>医药产品经理</td>\n",
       "      <td>15-20k</td>\n",
       "      <td>广州</td>\n",
       "      <td>49036529</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/2051572/</td>\n",
       "      <td>制药</td>\n",
       "      <td>1000-2000人</td>\n",
       "      <td>梁女士</td>\n",
       "      <td>NaN</td>\n",
       "      <td>d7754d4d4e4aa4da6dadb487287a091a</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>1cd0965588ebd1dba766278cd27a88c2</td>\n",
       "      <td>5bd962c38e50a3257f7c32d304a.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1</th>\n",
       "      <td>1</td>\n",
       "      <td>%7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"recruiterName\":\"刘女士\",\"jobId\":\"58002363\",\"imI...</td>\n",
       "      <td>['产品开发', '产品规划', '产品运营']</td>\n",
       "      <td>20230421104505</td>\n",
       "      <td>电商产品经理</td>\n",
       "      <td>10-15k·13薪</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>58002363</td>\n",
       "      <td>True</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/9720899/</td>\n",
       "      <td>批发/零售</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>刘女士</td>\n",
       "      <td>人事经理</td>\n",
       "      <td>561ff6e28a2e9cb4aa6795a3148228ff</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>e478580dede58f33b410edb79f6d12d0</td>\n",
       "      <td>5f8f986779c7cc70efbf36c008u.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2</th>\n",
       "      <td>2</td>\n",
       "      <td>%7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"recruiterName\":\"王女士\",\"jobId\":\"56876529\",\"imI...</td>\n",
       "      <td>[]</td>\n",
       "      <td>20230510113709</td>\n",
       "      <td>Automation Product Manager</td>\n",
       "      <td>20-40k·13薪</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>56876529</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/8506529/</td>\n",
       "      <td>医疗器械</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>王女士</td>\n",
       "      <td>人力资源专员</td>\n",
       "      <td>24c1cab13ef9bc2e801c17c79e240538</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>57a52ed73fed146b4c632be0178bfd3f</td>\n",
       "      <td>5f8f98648dbe6273dcf8515508u.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3</th>\n",
       "      <td>3</td>\n",
       "      <td>%7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"recruiterName\":\"李女士\",\"jobId\":\"58230073\",\"imI...</td>\n",
       "      <td>['支付产品', '工具产品', '供应链产品', '产品规划', '产品设计', '需求分...</td>\n",
       "      <td>20230429161907</td>\n",
       "      <td>支付结算产品经理（供应链）</td>\n",
       "      <td>20-40k·16薪</td>\n",
       "      <td>广州-番禺区</td>\n",
       "      <td>58230073</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/8537928/</td>\n",
       "      <td>消费品</td>\n",
       "      <td>5000-10000人</td>\n",
       "      <td>李女士</td>\n",
       "      <td>HR</td>\n",
       "      <td>01bdff5bdd175f73bed9c63c695716f7</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>4cb038ce180249e5b6d6f34ea69aacf8</td>\n",
       "      <td>62201c0397e97d36de7fadb308u.png</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4</th>\n",
       "      <td>4</td>\n",
       "      <td>%7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"recruiterName\":\"李先生\",\"jobId\":\"44389755\",\"imI...</td>\n",
       "      <td>['工具产品', '海外产品']</td>\n",
       "      <td>20230504101816</td>\n",
       "      <td>项目负责人-出海工具</td>\n",
       "      <td>50-60k·18薪</td>\n",
       "      <td>广州</td>\n",
       "      <td>44389755</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>NaN</td>\n",
       "      <td>在线社交/媒体</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>李先生</td>\n",
       "      <td>猎头顾问</td>\n",
       "      <td>a618aec32f807381e2a6e48d27d32952</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>7938d3385f4fa15e1077287a6124ac27</td>\n",
       "      <td>61c1856c1fe6ad2b061c38f408u.png</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>796</th>\n",
       "      <td>36</td>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"imId\":\"e225c3f62a005d602599e94...</td>\n",
       "      <td>['AI人工智能产品', 'IT互联网', '人工智能', '用户研究', '需求分析', ...</td>\n",
       "      <td>20221125101339</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>14-17k</td>\n",
       "      <td>广州-天河区</td>\n",
       "      <td>54434179</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/13240331/</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>杨女士</td>\n",
       "      <td>HR</td>\n",
       "      <td>e225c3f62a005d602599e94af0746e13</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>2e7227dee6993722f405701a339a50b5</td>\n",
       "      <td>62a44db9eb7f9e008716ed4208u.png</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>797</th>\n",
       "      <td>37</td>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"imId\":\"1fe1f195fb9b578b4036597...</td>\n",
       "      <td>['产品经理', '智能硬件产品', '智能硬件', '车载产品', '行车记录仪']</td>\n",
       "      <td>20230426171852</td>\n",
       "      <td>高级产品经理（硬件产品）</td>\n",
       "      <td>20-30k</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>51415121</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/12274147/</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>王女士</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1fe1f195fb9b578b4036597854bcf58c</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>3008edc8b1b12656a3c5bc684e468568</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>798</th>\n",
       "      <td>38</td>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"imId\":\"694fd92f6c2e08c7e2ff452...</td>\n",
       "      <td>[]</td>\n",
       "      <td>20230209091607</td>\n",
       "      <td>护肤品产品开发经理</td>\n",
       "      <td>10-20k</td>\n",
       "      <td>广州-海珠区</td>\n",
       "      <td>55885211</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/13413369/</td>\n",
       "      <td>电子商务</td>\n",
       "      <td>50-99人</td>\n",
       "      <td>麦女士</td>\n",
       "      <td>人事</td>\n",
       "      <td>694fd92f6c2e08c7e2ff452aa21dd897</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>5c70ee4140549e39609440013bae28b2</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>799</th>\n",
       "      <td>39</td>\n",
       "      <td>%7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...</td>\n",
       "      <td>{\"jobKind\":\"2\",\"imId\":\"16c9e99cc7e10c1f062c1b1...</td>\n",
       "      <td>['电商产品', 'IT互联网', '电子商务', '产品设计', '移动端产品', '产品...</td>\n",
       "      <td>20220224164403</td>\n",
       "      <td>产品经理</td>\n",
       "      <td>15-25k</td>\n",
       "      <td>广州</td>\n",
       "      <td>47448393</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/12677101/</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>1-49人</td>\n",
       "      <td>钟先生</td>\n",
       "      <td>人事经理</td>\n",
       "      <td>16c9e99cc7e10c1f062c1b1ee9c7454d</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>6b69b564e7d96f6957441703e35c1686</td>\n",
       "      <td>5f8f986aea60860b75384fab08u.jpg</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>800</th>\n",
       "      <td>0</td>\n",
       "      <td>%7B%22ckId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...</td>\n",
       "      <td>{\"userId\":\"3008edc8b1b12656a3c5bc684e468568\",\"...</td>\n",
       "      <td>['嵌入式硬件产品', '产品经理', '硬件产品经理', '硬件产品', '车载产品', ...</td>\n",
       "      <td>20230426171852</td>\n",
       "      <td>嵌入式硬件产品经理</td>\n",
       "      <td>20-30k</td>\n",
       "      <td>广州-越秀区</td>\n",
       "      <td>51414013</td>\n",
       "      <td>False</td>\n",
       "      <td>...</td>\n",
       "      <td>https://www.liepin.com/company/12274147/</td>\n",
       "      <td>计算机软件</td>\n",
       "      <td>100-499人</td>\n",
       "      <td>王女士</td>\n",
       "      <td>NaN</td>\n",
       "      <td>1fe1f195fb9b578b4036597854bcf58c</td>\n",
       "      <td>2.0</td>\n",
       "      <td>False</td>\n",
       "      <td>3008edc8b1b12656a3c5bc684e468568</td>\n",
       "      <td>5f8f9865ea60860b75384fa508u.jpg</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>801 rows × 32 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "     Unnamed: 0                                           dataInfo  \\\n",
       "0             0  %7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "1             1  %7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "2             2  %7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "3             3  %7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "4             4  %7B%22skId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "..          ...                                                ...   \n",
       "796          36  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "797          37  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "798          38  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "799          39  %7B%22jobKind%22%3A%222%22%2C%22pageSize%22%3A...   \n",
       "800           0  %7B%22ckId%22%3A%22h2c8pxojavrmo1w785z7ueih2yb...   \n",
       "\n",
       "                                            dataParams  \\\n",
       "0    {\"recruiterName\":\"梁女士\",\"jobId\":\"49036529\",\"imI...   \n",
       "1    {\"recruiterName\":\"刘女士\",\"jobId\":\"58002363\",\"imI...   \n",
       "2    {\"recruiterName\":\"王女士\",\"jobId\":\"56876529\",\"imI...   \n",
       "3    {\"recruiterName\":\"李女士\",\"jobId\":\"58230073\",\"imI...   \n",
       "4    {\"recruiterName\":\"李先生\",\"jobId\":\"44389755\",\"imI...   \n",
       "..                                                 ...   \n",
       "796  {\"jobKind\":\"2\",\"imId\":\"e225c3f62a005d602599e94...   \n",
       "797  {\"jobKind\":\"2\",\"imId\":\"1fe1f195fb9b578b4036597...   \n",
       "798  {\"jobKind\":\"2\",\"imId\":\"694fd92f6c2e08c7e2ff452...   \n",
       "799  {\"jobKind\":\"2\",\"imId\":\"16c9e99cc7e10c1f062c1b1...   \n",
       "800  {\"userId\":\"3008edc8b1b12656a3c5bc684e468568\",\"...   \n",
       "\n",
       "                                            job.labels  job.refreshTime  \\\n",
       "0                                                   []   20230412095614   \n",
       "1                             ['产品开发', '产品规划', '产品运营']   20230421104505   \n",
       "2                                                   []   20230510113709   \n",
       "3    ['支付产品', '工具产品', '供应链产品', '产品规划', '产品设计', '需求分...   20230429161907   \n",
       "4                                     ['工具产品', '海外产品']   20230504101816   \n",
       "..                                                 ...              ...   \n",
       "796  ['AI人工智能产品', 'IT互联网', '人工智能', '用户研究', '需求分析', ...   20221125101339   \n",
       "797        ['产品经理', '智能硬件产品', '智能硬件', '车载产品', '行车记录仪']   20230426171852   \n",
       "798                                                 []   20230209091607   \n",
       "799  ['电商产品', 'IT互联网', '电子商务', '产品设计', '移动端产品', '产品...   20220224164403   \n",
       "800  ['嵌入式硬件产品', '产品经理', '硬件产品经理', '硬件产品', '车载产品', ...   20230426171852   \n",
       "\n",
       "                      job.title  job.salary  job.dq  job.jobId  job.topJob  \\\n",
       "0                        医药产品经理      15-20k      广州   49036529        True   \n",
       "1                        电商产品经理  10-15k·13薪  广州-越秀区   58002363        True   \n",
       "2    Automation Product Manager  20-40k·13薪  广州-天河区   56876529       False   \n",
       "3                 支付结算产品经理（供应链）  20-40k·16薪  广州-番禺区   58230073       False   \n",
       "4                    项目负责人-出海工具  50-60k·18薪      广州   44389755       False   \n",
       "..                          ...         ...     ...        ...         ...   \n",
       "796                        产品经理      14-17k  广州-天河区   54434179       False   \n",
       "797                高级产品经理（硬件产品）      20-30k  广州-越秀区   51415121       False   \n",
       "798                   护肤品产品开发经理      10-20k  广州-海珠区   55885211       False   \n",
       "799                        产品经理      15-25k      广州   47448393       False   \n",
       "800                   嵌入式硬件产品经理      20-30k  广州-越秀区   51414013       False   \n",
       "\n",
       "     ...                                 comp.link comp.compIndustry  \\\n",
       "0    ...   https://www.liepin.com/company/2051572/                制药   \n",
       "1    ...   https://www.liepin.com/company/9720899/             批发/零售   \n",
       "2    ...   https://www.liepin.com/company/8506529/              医疗器械   \n",
       "3    ...   https://www.liepin.com/company/8537928/               消费品   \n",
       "4    ...                                       NaN           在线社交/媒体   \n",
       "..   ...                                       ...               ...   \n",
       "796  ...  https://www.liepin.com/company/13240331/             计算机软件   \n",
       "797  ...  https://www.liepin.com/company/12274147/             计算机软件   \n",
       "798  ...  https://www.liepin.com/company/13413369/              电子商务   \n",
       "799  ...  https://www.liepin.com/company/12677101/             计算机软件   \n",
       "800  ...  https://www.liepin.com/company/12274147/             计算机软件   \n",
       "\n",
       "    comp.compScale recruiter.recruiterName  recruiter.recruiterTitle  \\\n",
       "0       1000-2000人                     梁女士                       NaN   \n",
       "1           50-99人                     刘女士                      人事经理   \n",
       "2      5000-10000人                     王女士                    人力资源专员   \n",
       "3      5000-10000人                     李女士                        HR   \n",
       "4         100-499人                     李先生                      猎头顾问   \n",
       "..             ...                     ...                       ...   \n",
       "796          1-49人                     杨女士                        HR   \n",
       "797       100-499人                     王女士                       NaN   \n",
       "798         50-99人                     麦女士                        人事   \n",
       "799          1-49人                     钟先生                      人事经理   \n",
       "800       100-499人                     王女士                       NaN   \n",
       "\n",
       "                       recruiter.imId recruiter.imUserType  recruiter.chatted  \\\n",
       "0    d7754d4d4e4aa4da6dadb487287a091a                  2.0              False   \n",
       "1    561ff6e28a2e9cb4aa6795a3148228ff                  2.0              False   \n",
       "2    24c1cab13ef9bc2e801c17c79e240538                  2.0              False   \n",
       "3    01bdff5bdd175f73bed9c63c695716f7                  2.0              False   \n",
       "4    a618aec32f807381e2a6e48d27d32952                  2.0              False   \n",
       "..                                ...                  ...                ...   \n",
       "796  e225c3f62a005d602599e94af0746e13                  2.0              False   \n",
       "797  1fe1f195fb9b578b4036597854bcf58c                  2.0              False   \n",
       "798  694fd92f6c2e08c7e2ff452aa21dd897                  2.0              False   \n",
       "799  16c9e99cc7e10c1f062c1b1ee9c7454d                  2.0              False   \n",
       "800  1fe1f195fb9b578b4036597854bcf58c                  2.0              False   \n",
       "\n",
       "                recruiter.recruiterId         recruiter.recruiterPhoto  \n",
       "0    1cd0965588ebd1dba766278cd27a88c2  5bd962c38e50a3257f7c32d304a.jpg  \n",
       "1    e478580dede58f33b410edb79f6d12d0  5f8f986779c7cc70efbf36c008u.jpg  \n",
       "2    57a52ed73fed146b4c632be0178bfd3f  5f8f98648dbe6273dcf8515508u.jpg  \n",
       "3    4cb038ce180249e5b6d6f34ea69aacf8  62201c0397e97d36de7fadb308u.png  \n",
       "4    7938d3385f4fa15e1077287a6124ac27  61c1856c1fe6ad2b061c38f408u.png  \n",
       "..                                ...                              ...  \n",
       "796  2e7227dee6993722f405701a339a50b5  62a44db9eb7f9e008716ed4208u.png  \n",
       "797  3008edc8b1b12656a3c5bc684e468568  5f8f9865ea60860b75384fa508u.jpg  \n",
       "798  5c70ee4140549e39609440013bae28b2  5f8f9865ea60860b75384fa508u.jpg  \n",
       "799  6b69b564e7d96f6957441703e35c1686  5f8f986aea60860b75384fab08u.jpg  \n",
       "800  3008edc8b1b12656a3c5bc684e468568  5f8f9865ea60860b75384fa508u.jpg  \n",
       "\n",
       "[801 rows x 32 columns]"
      ]
     },
     "execution_count": 18,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df = pd.read_excel('liepin_PM_0510.xlsx')\n",
    "df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 19,
   "id": "c13c9cf5",
   "metadata": {},
   "outputs": [],
   "source": [
    "import sys"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "id": "3a930207",
   "metadata": {},
   "outputs": [],
   "source": [
    "import string\n",
    "\n",
    "import requests \n",
    "import json\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 35,
   "id": "aa230827",
   "metadata": {},
   "outputs": [],
   "source": [
    "df_job_title = df['job.title'].apply(lambda x:x.split(' (' )[0].split('/')[0].split('(')[0]).value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 36,
   "id": "d5af0b26",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "产品经理                      183\n",
       "高级产品经理                     31\n",
       "软件产品经理                     16\n",
       "AI产品经理                     12\n",
       "电商产品经理                     10\n",
       "                         ... \n",
       "代客代理中心产品经理岗（衍生品交易产品经理）      1\n",
       "产品推广技术经理                    1\n",
       "全国产品经理                      1\n",
       "产品总监/高级产品经理（固网）             1\n",
       "嵌入式硬件产品经理                   1\n",
       "Name: job.title, Length: 467, dtype: int64"
      ]
     },
     "execution_count": 36,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "df['job.title'].value_counts()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 45,
   "id": "baf4401d",
   "metadata": {},
   "outputs": [],
   "source": [
    "from pyecharts.charts import WordCloud\n",
    "from pyecharts import options as opts\n",
    "from pyecharts.globals import SymbolType\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 46,
   "id": "504dbbb9",
   "metadata": {},
   "outputs": [],
   "source": [
    "sj = [(  df_job_title.index.tolist()[i]  ,df_job_title.values.tolist()[i]  )     for i in range(1,len(df_job_title.index.tolist()) )]"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 49,
   "id": "6d1975a9",
   "metadata": {},
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[('高级产品经理', 37),\n",
       " ('软件产品经理', 17),\n",
       " ('AI产品经理', 12),\n",
       " ('电商产品经理', 12),\n",
       " ('数据产品经理', 10),\n",
       " ('硬件产品经理', 9),\n",
       " ('数据中台产品经理', 7),\n",
       " ('AI应用产品经理', 6),\n",
       " ('医药产品经理', 6),\n",
       " ('金融产品经理', 5),\n",
       " ('海外产品经理', 4),\n",
       " ('智能硬件产品经理', 4),\n",
       " ('助理产品经理', 4),\n",
       " ('产品经理（大数据）', 3),\n",
       " ('金融科技产品经理', 3),\n",
       " ('产品主管', 3),\n",
       " ('产品经理（数字化）', 3),\n",
       " ('区域产品经理', 3),\n",
       " ('医疗信息化产品经理', 3),\n",
       " ('资深产品经理', 3),\n",
       " ('售前产品经理', 3),\n",
       " ('供应链产品经理', 3),\n",
       " ('医学产品经理', 3),\n",
       " ('产品经理（广州）', 3),\n",
       " ('展业系统产品经理', 3),\n",
       " ('OTC区域产品经理', 3),\n",
       " ('硬件产品经理（双休+五险一金）', 2),\n",
       " ('高级WMS产品经理', 2),\n",
       " ('eWMS Product Manager', 2),\n",
       " ('跨境电商产品经理', 2),\n",
       " ('数码产品经理', 2),\n",
       " ('快消品产品经理', 2),\n",
       " ('Assistant Product Manager ', 2),\n",
       " ('产品经理（商品中心）', 2),\n",
       " ('产品经理（财务方向）', 2),\n",
       " ('服务产品经理', 2),\n",
       " ('CRM产品经理', 2),\n",
       " ('产品运营', 2),\n",
       " ('暖通产品经理', 2),\n",
       " ('产品经理（报价系统）', 2),\n",
       " ('产品经理（工控主板）', 2),\n",
       " ('化妆品产品经理', 2),\n",
       " ('产品经理岗', 2),\n",
       " ('肾线助理产品经理', 2),\n",
       " ('产品负责人', 2),\n",
       " ('软件产品经理（实验实训）', 2),\n",
       " ('物联网产品经理', 2),\n",
       " ('金融科技产品经理岗', 2),\n",
       " ('高级TMS产品经理', 2),\n",
       " ('MES产品经理', 2),\n",
       " ('食品产品经理', 2),\n",
       " ('B端供应链产品经理', 2),\n",
       " ('供需调度产品经理（正式员工，双休）', 1),\n",
       " ('电商产品经理（日化家清类目）', 1),\n",
       " ('产品运营经理', 1),\n",
       " (' Product Manager ', 1),\n",
       " ('eWMS产品经理', 1),\n",
       " ('电商硬件产品经理', 1),\n",
       " ('用户增长产品经理（web3.0-英语流利）', 1),\n",
       " ('IT产品经理', 1),\n",
       " ('美食产品经理-主食', 1),\n",
       " ('安全产品经理', 1),\n",
       " ('高级产品经理（硬件产品）', 1),\n",
       " ('解决方案产品经理', 1),\n",
       " ('Automation Product Manager', 1),\n",
       " ('云桌面终端产品经理', 1),\n",
       " ('B端产品经理（CRM）', 1),\n",
       " ('临床产品经理', 1),\n",
       " ('初级产品经理', 1),\n",
       " ('中高级产品经理（智能客服线+SaaS行业）', 1),\n",
       " ('产品经理（支付）', 1),\n",
       " ('穿戴甲产品经理', 1),\n",
       " ('软件产品经理（个人办公）', 1),\n",
       " ('产品经理（科研耗材', 1),\n",
       " ('AJ1288-SPBU-高级产品经理', 1),\n",
       " ('消费者BU 软件产品经理', 1),\n",
       " ('GTD-PP-003：产品经理', 1),\n",
       " ('智慧物流-产品经理', 1),\n",
       " ('软件产品经理（上市公司  教育）', 1),\n",
       " ('数字营销PM', 1),\n",
       " ('硬件高级产品经理', 1),\n",
       " ('自动驾驶（硬件）产品经理', 1),\n",
       " ('智能机械软件产品经理', 1),\n",
       " ('ERP产品经理', 1),\n",
       " ('K12教学工具产品经理', 1),\n",
       " ('研究所数字化产品经理', 1),\n",
       " ('产品经理（护肤品产品经理）', 1),\n",
       " ('水稻产品经理', 1),\n",
       " ('高级产品经理（物流', 1),\n",
       " ('照明产品经理', 1),\n",
       " ('产品经理（直播，私域社群）-国企正编', 1),\n",
       " ('医院后勤管理平台产品经理', 1),\n",
       " ('微生物检测产品经理（制药或食品行业方向）', 1),\n",
       " ('产品经理（大健康）', 1),\n",
       " ('（储备）产品经理--20-22届本科', 1),\n",
       " ('互联网运营岗（产品解决方案方向）', 1),\n",
       " ('B端供应链产品经理（采购系统）', 1),\n",
       " ('风控产品经理（P7）', 1),\n",
       " ('产品经理（大家电商务）', 1),\n",
       " ('产品经理（国际售后服务）', 1),\n",
       " ('海外产品需求支持主任', 1),\n",
       " ('中级产品经理', 1),\n",
       " ('产品拓展经理（园区交换方向）', 1),\n",
       " ('产品经理（账务处理中心）-国企正编', 1),\n",
       " ('产品经理（HIS）', 1),\n",
       " ('eWMS', 1),\n",
       " ('市场产品经理（偏售前）', 1),\n",
       " ('WXG11-微信读书高级产品策划（广州）', 1),\n",
       " ('医药中央市场产品经理', 1),\n",
       " ('软件产品经理（海外）', 1),\n",
       " ('移动高级产品经理', 1),\n",
       " ('软件产品经理（实验实训）（A股上市龙头）', 1),\n",
       " ('数据产品经理（AI方向）', 1),\n",
       " ('高级产品经理（商家', 1),\n",
       " ('产品经理（日结中心）-国企正编', 1),\n",
       " ('产品经理（建筑照明）', 1),\n",
       " ('固收条线金融科技产品经理', 1),\n",
       " ('产品经理 （建站方向）', 1),\n",
       " ('高级项目管理PM（游戏研发）-正编', 1),\n",
       " ('产品经理（审计、企业数字化方向）', 1),\n",
       " ('中台产品经理', 1),\n",
       " ('产品经理（客户需求）', 1),\n",
       " ('高级产品经理（常驻迪拜）', 1),\n",
       " ('交易支付产品经理', 1),\n",
       " ('产品经理（积木）--TOP TOY', 1),\n",
       " ('产品经理（商品中心）-国企正编', 1),\n",
       " ('商家产品经理', 1),\n",
       " ('产品经理（EHS，能用管理，碳排放）', 1),\n",
       " ('高级产品经理（应急）', 1),\n",
       " ('产品经理（生殖遗传方向）', 1),\n",
       " ('PS', 1),\n",
       " ('高级产品经理（国际车联网）', 1),\n",
       " ('产品经理（金融产品）', 1),\n",
       " ('中级用户研究员（产品用研）', 1),\n",
       " ('产品经理（双休）', 1),\n",
       " (' AI应用产品经理', 1),\n",
       " ('产品经理-产品企划（鞋类）', 1),\n",
       " ('整机产品经理', 1),\n",
       " ('智慧环保产品经理', 1),\n",
       " ('IT平台产品经理主管工程师', 1),\n",
       " ('数据ai产品经理', 1),\n",
       " ('产品经理（临床）', 1),\n",
       " ('产品经理（智能硬件）', 1),\n",
       " ('B端供应链产品经理（商家系统）', 1),\n",
       " ('支付结算产品经理（供应链）', 1),\n",
       " ('产品经理（银行实物运营管理产品方向） ', 1),\n",
       " ('数据产品经理（金融方向）', 1),\n",
       " ('产品经理（电力行业市场侧）', 1),\n",
       " ('境外产品经理（新加坡）', 1),\n",
       " ('平台产品经理', 1),\n",
       " ('产品经理（新能源行业）', 1),\n",
       " ('市场部产品经理', 1),\n",
       " ('网络金融部产品经理', 1),\n",
       " ('高级产品经理（会员营销方向）', 1),\n",
       " ('固网产品总监', 1),\n",
       " ('PM顾问', 1),\n",
       " ('高级产品经理（自动化运维平台产品）', 1),\n",
       " ('APP产品经理', 1),\n",
       " ('AI应用产品经理（广州总部）# 90M0115489', 1),\n",
       " ('社交电商产品经理', 1),\n",
       " ('跨境产品开发', 1),\n",
       " ('产品经理（家政事业部）', 1),\n",
       " ('自动驾驶数据产品测试主管工程师', 1),\n",
       " ('项目负责人-出海工具', 1),\n",
       " ('产品经理（物联感知云平台）', 1),\n",
       " ('电商硬件产品经理（A股上市公司）', 1),\n",
       " ('AI应用产品经理-知名保健公司', 1),\n",
       " ('产品经理-PTN', 1),\n",
       " ('高级产品经理（OA流程产品）', 1),\n",
       " ('产品经理-产品企划', 1),\n",
       " ('软件产品经理（个人办公PC端产品）', 1),\n",
       " ('企业微信产品策划经理（广州', 1),\n",
       " ('口腔产品经理', 1),\n",
       " ('上市厂商产品经理', 1),\n",
       " ('高级产品经理（商显整机）', 1),\n",
       " ('产品经理（宠物行业）', 1),\n",
       " ('产品经理 （财税', 1),\n",
       " ('垂直电商产品经理', 1),\n",
       " ('医疗产品经理', 1),\n",
       " ('运营商售前产品经理', 1),\n",
       " ('产品经理（CRM', 1),\n",
       " ('外贸产品经理', 1),\n",
       " ('产品经理（基因检测）', 1),\n",
       " ('产品经理（pc软件）', 1),\n",
       " ('产品经理（医疗器械', 1),\n",
       " ('产品经理（游戏营收）', 1),\n",
       " ('服务器产品经理（信创）', 1),\n",
       " ('高级产品经理（家庭储能）', 1),\n",
       " ('支付产品经理', 1),\n",
       " ('产品核价师', 1),\n",
       " ('英文流利的海外SFA产品经理', 1),\n",
       " ('投资交易业务系统产品经理', 1),\n",
       " ('AI产品经理（部门cpkfcx）', 1),\n",
       " ('游戏PM', 1),\n",
       " ('市场产品经理', 1),\n",
       " ('产品经理（平板', 1),\n",
       " ('信息流产品经理', 1),\n",
       " ('家居-产品经理', 1),\n",
       " ('产品经理（金融类产品）', 1),\n",
       " ('高级产品经理（视觉感知系统、智能载荷）', 1),\n",
       " ('产品总监', 1),\n",
       " ('产品经理（双休跨境自研）', 1),\n",
       " ('仓储产品方案工程师', 1),\n",
       " ('产品规划经理（园区交换方向）', 1),\n",
       " ('AI产品经理岗', 1),\n",
       " ('高级产品经理（场景营销方向）', 1),\n",
       " ('产品经理（自然资源）', 1),\n",
       " ('产品经理（广州+海南）', 1),\n",
       " ('品质PM', 1),\n",
       " ('产品经理（数据方向）', 1),\n",
       " ('商业化产品经理-出海工具产品', 1),\n",
       " ('产品经理（双休+五险一金）', 1),\n",
       " ('产品经理（企业数字化转型）', 1),\n",
       " ('化妆品原料产品经理', 1),\n",
       " ('储备产品经理', 1),\n",
       " ('产品经理（物联网）', 1),\n",
       " ('产品经理（英语）', 1),\n",
       " ('证券金融IT产品经理', 1),\n",
       " ('家具产品经理', 1),\n",
       " ('产品经理（电视类）', 1),\n",
       " ('项目经理', 1),\n",
       " ('b端产品经理', 1),\n",
       " ('心血管产品线总经理', 1),\n",
       " ('产品主管（物联网', 1),\n",
       " ('神外产品销售经理 Product Sales Manager', 1),\n",
       " ('数字化产品经理岗', 1),\n",
       " ('数据治理产品经理', 1),\n",
       " ('AI应用产品经理 ', 1),\n",
       " ('医疗器械产品经理', 1),\n",
       " ('产品经理（医药行业）', 1),\n",
       " ('产品负责人（播放器框架）', 1),\n",
       " ('PTBU-高级产品经理（个性化推荐）', 1),\n",
       " ('产品经理（供应链质量检测系统）', 1),\n",
       " ('产品经理（数码，SSD，U盘，移动电源）', 1),\n",
       " ('产品经理（人力资源数字化）', 1),\n",
       " ('自动驾驶数据产品研发主管工程师', 1),\n",
       " ('APP高级产品经理', 1),\n",
       " ('广花融资担保公司（筹）产品经理', 1),\n",
       " ('活动PM', 1),\n",
       " ('文创产品经理', 1),\n",
       " ('产品经理（交通物流）', 1),\n",
       " ('高级硬件产品经理', 1),\n",
       " ('产品经理（客户中心)-国企正编', 1),\n",
       " ('ERP产品经理（跨境电商-双休）', 1),\n",
       " ('产品经理（工业消洗产品）', 1),\n",
       " ('ZNXT-产品经理（IoT）', 1),\n",
       " ('产品经理（化妆品原料）', 1),\n",
       " ('高级数据产品经理（供应链领域）', 1),\n",
       " ('软件产品经理（PC云桌面）', 1),\n",
       " ('IOT产品经理', 1),\n",
       " ('大数据产品经理', 1),\n",
       " ('区域产品经理（广州）-肿瘤', 1),\n",
       " ('产品经理（高级产品经理&资深产品经理）', 1),\n",
       " ('B端产品经理（供应商系统', 1),\n",
       " ('充电-产品经理', 1),\n",
       " ('助理产品经理（化妆品原料）', 1),\n",
       " ('私募产品经理', 1),\n",
       " ('产品经理（库存中心）-国企正编', 1),\n",
       " ('云网产品经理（部门）', 1),\n",
       " ('海外社交产品经理（APP）', 1),\n",
       " ('Product Sales Manager MR 产品销售经理 广州', 1),\n",
       " ('产品高级专员（策划与开发）', 1),\n",
       " ('风控产品经理', 1),\n",
       " ('产品经理（物联平台）', 1),\n",
       " ('产品经理岗（信息技术）', 1),\n",
       " ('产品经理（舞台灯光）', 1),\n",
       " ('产品销售经理-广州', 1),\n",
       " ('IT产品经理岗（资产托管方向）', 1),\n",
       " ('国企正编-产品经理（多个方向）', 1),\n",
       " ('软件产品经理（已上市，业内龙头企业）', 1),\n",
       " ('硬件产品经理（教育PC硬件）', 1),\n",
       " ('人脸产品经理', 1),\n",
       " ('国际物流产品经理', 1),\n",
       " ('亚马逊高级产品开发专员', 1),\n",
       " ('照明-产品经理', 1),\n",
       " ('高级产品经理（SaaS方向）', 1),\n",
       " ('OTC产品经理', 1),\n",
       " ('电商产品经理（小家电）', 1),\n",
       " ('产品经理（B端）', 1),\n",
       " ('crm高级产品经理', 1),\n",
       " ('产品经理，平板笔记本方向', 1),\n",
       " ('产品经理（财经方向）', 1),\n",
       " ('护肤品产品开发经理', 1),\n",
       " ('经营分析岗（快运产品方向）', 1),\n",
       " ('产品经理（风控前台)-国企正编', 1),\n",
       " ('产品增长运营（广州）', 1),\n",
       " ('产品经理（粤政易）', 1),\n",
       " ('电商硬件产品经理（宠物家电', 1),\n",
       " ('产品经理（银行线）', 1),\n",
       " ('硬件产品经理（3C', 1),\n",
       " ('高级产品经理（无人机载荷与视觉）', 1),\n",
       " ('产品经理（预售，员工分销）-国企正编', 1),\n",
       " ('语音直播产品经理', 1),\n",
       " ('智能机械硬件产品经理', 1),\n",
       " ('产品经理-安全方向（广州）', 1),\n",
       " ('高级产品', 1),\n",
       " ('高级产品开发员', 1),\n",
       " ('潮玩盲盒产品经理', 1),\n",
       " ('展业系统主任 ', 1),\n",
       " ('临床试验项目经理PM', 1),\n",
       " ('售后研发产品经理（售后服务系统400，工单，结算，配件，库存）', 1),\n",
       " ('C端产品经理', 1),\n",
       " ('广告系统产品经理', 1),\n",
       " ('新能源产品经理', 1),\n",
       " ('游戏直播产品经理', 1),\n",
       " ('民航产品经理', 1),\n",
       " ('硬件产品经理（云屏）', 1),\n",
       " ('高级产品经理（心血管）', 1),\n",
       " ('数据安全产品经理', 1),\n",
       " ('营收产品经理', 1),\n",
       " ('高级产品经理（OA）', 1),\n",
       " ('产品经理（麻醉）', 1),\n",
       " ('可视化产品经理', 1),\n",
       " ('产品总监-逆变器', 1),\n",
       " ('高级', 1),\n",
       " ('海外软件产品经理（A股上市龙头企业）', 1),\n",
       " ('电商高级产品经理（APP方向）', 1),\n",
       " ('产品经理 - eWMS', 1),\n",
       " ('产品总监（产品+营销）', 1),\n",
       " ('出境旅游产品经理', 1),\n",
       " ('产品经理（海外业务）', 1),\n",
       " ('产品服务经理岗', 1),\n",
       " ('产品经理（平板笔电）', 1),\n",
       " ('产品经理-金融方向', 1),\n",
       " ('企业支付产品经理', 1),\n",
       " ('安全类产品经理', 1),\n",
       " ('产品规划经理（水果类）', 1),\n",
       " ('产品经理（外贸', 1),\n",
       " ('NGS产品经理', 1),\n",
       " ('产品经理（食品类）', 1),\n",
       " ('产品经理（社交平台）', 1),\n",
       " ('高级产品经理（业务中台） 外企正编', 1),\n",
       " ('CRM实施顾问&项目经理PM', 1),\n",
       " ('硬件高级产品经理（会议', 1),\n",
       " ('B端产品经理', 1),\n",
       " ('高级产品经理（海外HR产品）', 1),\n",
       " ('产品专员', 1),\n",
       " ('产品经理（智能家居）', 1),\n",
       " ('软件开发产品经理', 1),\n",
       " ('工具规划产品经理', 1),\n",
       " ('跨境电商产品经理（汽配类）', 1),\n",
       " ('软件产品经理（个人办公', 1),\n",
       " ('RPA产品经理', 1),\n",
       " ('AI应用产品经理（推荐、预测类，实操算法、应用场景设计）', 1),\n",
       " ('高级产品经理（电商APP方向）', 1),\n",
       " ('产品经理-海外', 1),\n",
       " ('数据产品经理（中台）', 1),\n",
       " ('互联网产品经理', 1),\n",
       " ('（储备）产品经理', 1),\n",
       " ('产品经理（工具产品）', 1),\n",
       " ('BI产品经理', 1),\n",
       " ('产品经理（用户运营）', 1),\n",
       " ('产品经理-肿瘤', 1),\n",
       " ('产品工程师（新能源）', 1),\n",
       " ('芯片产品经理', 1),\n",
       " ('算法产品经理', 1),\n",
       " ('高级产品经理（面料整合系统）', 1),\n",
       " ('视频类产品经理', 1),\n",
       " ('高级产品经理（B端效能工具）', 1),\n",
       " ('产品经理（国内车联网）', 1),\n",
       " ('产品策划经理', 1),\n",
       " ('电商产品经理（工具类）', 1),\n",
       " ('高级产品开发经理', 1),\n",
       " ('产品经理（语音房玩法）', 1),\n",
       " ('政务产品经理', 1),\n",
       " ('B端产品经理（商家', 1),\n",
       " ('电商物流产品经理', 1),\n",
       " ('产品经理（业务平台方向）', 1),\n",
       " ('医药高级产品经理', 1),\n",
       " ('PM II', 1),\n",
       " ('产品经理（医药）', 1),\n",
       " ('数据产品经理（要会Python）', 1),\n",
       " ('硬件产品经理（照明类产品）', 1),\n",
       " ('数据产品经理-经营分析及供应链方向', 1),\n",
       " ('高级硬件产品经理（高速信号测量设备、雷达配套设备）', 1),\n",
       " ('产品经理Product Manager', 1),\n",
       " ('B端产品经理G00941', 1),\n",
       " ('高级产品经理（B端）', 1),\n",
       " ('产品经理（大气监测组分网）', 1),\n",
       " ('产品策划专家II', 1),\n",
       " ('产品经理（分子诊断）', 1),\n",
       " ('数字化产品经理', 1),\n",
       " ('项目发行PM（二次元）', 1),\n",
       " ('高级数据产品经理（腾讯战略投资企业）', 1),\n",
       " ('产品经理（互联网医疗', 1),\n",
       " ('产品经理（活动营销类）', 1),\n",
       " ('专科专病产品经理', 1),\n",
       " ('SDK产品经理', 1),\n",
       " ('高级数据产品经理', 1),\n",
       " ('CRM产品经理（B端）', 1),\n",
       " ('彩妆产品经理', 1),\n",
       " ('高级产品经理（数据方向）', 1),\n",
       " ('产品经理（音响音箱耳机等）', 1),\n",
       " ('全国产品经理', 1),\n",
       " ('互联网医疗产品经理', 1),\n",
       " ('咨询顾问', 1),\n",
       " ('产品经理助理', 1),\n",
       " ('卡券工具平台产品经理', 1),\n",
       " ('高级产品经理-', 1),\n",
       " ('金币项目高级产品经理', 1),\n",
       " ('LIMS产品经理', 1),\n",
       " ('芯片产品经理（广州）', 1),\n",
       " ('产品经理（感染方向）', 1),\n",
       " ('产品经理（固收）', 1),\n",
       " ('产品经理（凡科商城SaaS）', 1),\n",
       " ('高级产品PM', 1),\n",
       " ('产品推广技术经理', 1),\n",
       " ('海外软件产品经理', 1),\n",
       " ('产品经理（应急行业）', 1),\n",
       " ('产品经理（数码）', 1),\n",
       " ('产品经理（电商）', 1),\n",
       " ('产品经理（需要有护照）', 1),\n",
       " ('助理产品经理—食品类', 1),\n",
       " ('高级SSP产品经理', 1),\n",
       " ('客户端产品经理（985', 1),\n",
       " ('代客代理中心产品经理岗（衍生品交易产品经理）', 1),\n",
       " ('嵌入式硬件产品经理', 1)]"
      ]
     },
     "execution_count": 49,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "sj"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 50,
   "id": "b34bbea8",
   "metadata": {},
   "outputs": [],
   "source": [
    "c = (\n",
    "    WordCloud()\n",
    "    .add(\"\", sj,word_size_range=[30, 100],shape='diamond')\n",
    "    .set_global_opts(title_opts=opts.TitleOpts(title=\"www\"))\n",
    "    .render(\"56.html\")\n",
    ")"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "d45a7258",
   "metadata": {},
   "outputs": [],
   "source": []
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "id": "b611c58a",
   "metadata": {},
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.8.8"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 5
}
